Microsoft« ActiveX« Data Objects (ADO) enable your client applications to access and manipulate data from a database server through an OLE DB provider.
ADO supports key features for building client/server and Web-based applications. Its primary benefits are ease of use, high speed, low memory overhead, and a small disk footprint. ADO also features Remote Data Service (RDS), by which you can move data from a server to a client application or Web page, manipulate the data on the client, and return updates to the server in a single round trip.
To learn more about ADO, see the ADO Programmer's Reference.
ActiveX Data Objects Extensions for Data Definition Language and Security (ADOX) extends ADO to include objects for creating, modifying, and deleting schema objects, such as tables and procedures. It also includes security objects to maintain users and groups and to grant and revoke permissions on objects.
To learn more about ADOX, see the ADOX Programmer's Reference.
ActiveX Data Objects (Multidimensional) (ADO MD) extends ADO to include objects specific to multidimensional data, and allows you to browse multidimensional schema, query a cube, and retrieve the results.
To learn more about ADO MD, see the ADO MD Programmer's Reference.
For information about the Microsoft Data Access Components SDK, see the MDAC SDK Overview in the Platform SDK.